Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

PROC–HANDLE function

Returns the appropriate return value data type (usually integer) that acts as a unique identifier for an ODBC stored procedure:

Syntax

PROC-HANDLE

Example

This procedure runs the stored procedure pcust and writes the procedure handle to the variable hdl. It writes the results of the stored procedure identified by this procedure handle into the Progress 4GL buffer, proc–text–buffer, and displays it:

DEFINE VAR hdl AS INTEGER. RUN STORED-PROCEDURE pcust hdl = PROC-HANDLE (10, OUTPUT 0, OUTPUT 0). FOR EACH proc-text-buffer WHERE PROC-HANDLE = hdl: DISPLAY proc-text. END. CLOSE STORED-PROCEDURE pcust WHERE PROC-HANDLE = hdl.

Notes

Progress Software Corporation recommends that you specify a procedure handle for each stored procedure that you run.
You do not have to specify a handle if there is only one active stored procedure and you do not include SQL statements in the application.

See also

CLOSE STORED–PROCEDURE statement, PROC–STATUS function, RUN STORED–PROCEDURE statement